PowerBI

Power BI

1.1 Power BI Introduction

1.2 Power BI Installation

1.3 Adjusting Settings

1.4 Workflow of Power BI

1.5 Power BI Helpful Resources

2.1 Front End vs back End

2.2 Types of Data Connectors

2.3 POWER QUERY EDITOR

2.4 Basic Data Transformations

2.5 Assignment-1-Table Transformation Assignment

2.6 Assignment-1-Table Transformation- Assignment Solution

2.7 Storage and Connection Mode

2.8 Connecting To Database

2.9 Website Data Gathering

2.10 Data profiling and QA Tools

2.11 Text Tools Transformation

2.12 Assignment-2-Text Tools

2.13 Assignment-2-Text-Tools-Solution

2.14 Numeric Tools

2.15 Assignment-3-Numeric Tools

2.16 Assignment-3-Numeric Tools-Solution

2.17 DATE AND TIME TOOLS

2.18 Change Type with Locale

2.19 Rolling Calendar

2.20 Assignment-4-Calendar tables Assignment

2.21 Assignment-4-Calender Tables-Solutions

2.22 Index and Conditional Column

2.23 Grouping and Aggregating

2.24 Pivoting and Unpivoting

2.25 Merging Queries

2.26 Appending Queries

2.27 Data Gathering From Folder

2.28 Data Source Settings

2.29 Refresh Button

2.30 importing Excel Models

3.1 Creating A Data Model Introduction

3.2 What is a Data Model

3.3 Database Normalization

3.4 Fact And Dimension Tables

3.5 PRIMARY AND FOREIGN KEYS

3.6 Merged Table vs Relationships

3.7 Creating Table Relationship

3.8 Managing and Editing Relationship

3.9 Star and SnowFlake Schema

3.10 Assignment-1-Table-Relationships

3.11 Assignment-1-Table Relationships- Solution

3.12 Active and Inactive Relationship

3.13 Relationship Cardinality

3.14 Connectng Multiple Fact Tables

3.15 Filter Context and Filter Flow

3.16 BiDirectional Filter and Ambiguity

3.17 Hide in Report View

3.18 Assignment-2-Filter Flow

3.19 Assignment-2-Filter Flow-Solution

3.20 Model Layouts

3.21 Data Format and Category

3.22 Heirarchies

3.23 Assignment-3-Heirarchies

3.24 Assignment-3-Heirarchies-Solution

4.1 DAX Introduction

4.2 Dax Vs M Code

4.3 Dax Measures

4.4 Implicit vs Explicit Measures

4.5 Quick Measures

4.6 Measure Tables

4.7 Filter Context

4.8 Dax Syntax and Operators

4.9 Common Function Category

4.10 Basic Math and Stats Function

4.11 Counting functions

4.12 Assignment-1-Maths and Stats

4.13 Assignment-1-Maths and Stats-Solutions

4.14 Conditional and Logical Functions

4.15 Switch Function

4.16 Assignment-2-Logical functions

4.17 Assignment-2-Logical functions-Solution

4.18 Text Functions

4.19 Assignment-3-Text functions

4.20 Assignment-3-Text functions-Solution

4.21 Date and Time Functions

4.22 Assignment-4-Date and Time

4.23 Assignment-4-Date and Time-Solutions

4.24 Joining Data with Related

4.25 Calculate Function

4.26 DAX Measure Totals

4.27 Assignment-5-Calculate Function

4.28 Assignment-5-Calculate Function-Solutions

4.29 ALL Function

4.30 Assignment-6-Calculate and ALL

4.31 Assignment-6-Calculate and ALL-Solution

4.32 Filter Functions

4.33 Iterator Functions

4.34 Assignment-7-Iterators

4.35 Assignment-7-Iterators-Solution

4.36 Time Intelligence Patterns

4.37 Assignment-8-Time Intelligence

4.38 Assignment-8-Time Intelligence-Solutions

5.1 Dashboard Intro and three key questions

5.2 Dashboard Sketch

5.3 Adding Report Pages and objects

5.4 Naming and Grouping Objects

5.5 Cards and Multi Row Cards

5.6 Assignment-1-Cards

5.7 Assignment-1-cards-solution

5.8 Line Charts

5.9 Trend lines and Forecasts

5.10 Assignment-2-Line Charts

5.11 Assignment-2-Line Charts-Solution

5.12 KPI Visuals

5.13 Bar and Donut Charts

5.14 Filtering Options

5.15 Assignment-3-Donuts and Filters

5.16 Assignment-3-Donut Charts and Filters-Solution

5.17 Table and Matrix Visuals

5.18 Conditional Formatting

5.19 TOP N Filtering

5.20 Assignment-4-tables

5.21 Assignment-4-Tables-Solution

5.22 Top N Text Cards

5.23 Assignment-5-Top N Text Cards

5.24 Assignment-5-Top N Text Cards-Solution

5.25 Map Visuals

5.26 Slicers

5.27 Assignment-5-Slicers

5.28 Assignment-5-Slicers-Solution

5.29 HasOne Values Function

5.30 Gauge Chart

5.31 Advanced Conditional Formatting

5.32 Area Chart Visual

5.33 Drill Up and Drill Down Tools

5.34 Assignment-6-Drill up and Drill Down

5.35 Assignment-6-Drill Up and Drill Down-Solution

5.36 Drill Through Filters

5.37 Report Interactions

5.38 Assignment-7-Report Interactions

5.39 Assignment-7-Report Interactions-Solution

5.40 Bookmarks

5.41 Assignment-8-Bookmarks

5.42 Assignment-8-Bookmarks-Solution

5.43 Navigation Buttons

5.44 Slicer Panel

5.45 Parameters

5.46 Assignment-9-Field Parameters

5.47 Assignment-9-Field Parameters-Solution

5.48 Custom ToolTip

5.49 Power BI service Sign In

5.50 Importing Custom Visuals

5.51 Mobile Layout

5.52 Publishing Dashboard

6.1 Anomaly Detection

6.2 Smart Narrative

6.3 Q and A Visual

6.4 Decomposition Trees

6.5 Key Influencers

7.1 Pause Visuals

7.2 Optimization Preset

7.3 Apply all Slicers Button

7.4 Performance Analyzer

8.1 Power BI New Features and Updates

Select a lecture to begin